<?php 

$sql = "
select 
    TABLE_NAME			AS TABLE_NAME,
    CONSTRAINT_NAME     AS INDEX_NAME,
    COLUMN_NAME			AS COLUMN_NAME,
    ORDINAL_POSITION	AS COLUMN_POSITION,
    ''					AS DESCEND,
	''					AS UQ,	
	''					AS PK,
	''					AS INDEX_TYPE,
	''					AS ISNULL,
	''					AS COMMENT
from 
	information_schema.key_column_usage
where table_schema = '{$param['schema']}'
	and table_name = '{$param['object']}'
order by 
	ORDINAL_POSITION
    
";

return $this->getData($sql);


?>